package sfa.model;

public class DeleteDao extends BaseDao {

	public void deleteObs(String obsNo) {
		String query1 = "delete from DBSPOTAPP.dbo.OPR_OBSTACLE where obs_no = ?";
		String query2 = "delete from DBSPOTAPP.dbo.OPR_OBS_BIZ_TYPE where obs_no = ?";
		String query3 = "delete from DBSPOTAPP.dbo.OPR_OBS_RSN where obs_no = ?";
		String query4 = "delete from DBSPOTAPP.dbo.OPR_DIPOSER where obs_no = ?";
		String query5 = "delete from DBSPOTAPP.dbo.OPR_PLAN where obs_no = ?";
		String query6 = "delete from DBSPOTAPP.dbo.OPR_EFFECT where obs_no = ?";
		String query7 = "delete from DBSPOTAPP.dbo.OPR_PROCESS where obs_no = ?";
		
		getJdbcTemplate().update(query1, new Object[] { obsNo });	
		getJdbcTemplate().update(query2, new Object[] { obsNo });	
		getJdbcTemplate().update(query3, new Object[] { obsNo });	
		getJdbcTemplate().update(query4, new Object[] { obsNo });	
		getJdbcTemplate().update(query5, new Object[] { obsNo });	
		getJdbcTemplate().update(query6, new Object[] { obsNo });	
		getJdbcTemplate().update(query7, new Object[] { obsNo });	
	}

}
